clear
import excel "C:\Users\david.medina\Desktop\Capitulo 3\Final Documents\Stata.xlsx", sheet("Hoja1") firstrow
tsset code year

//// Table 2


xtreg Totalcrimes term_limit *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop indep unemployment1 ,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totalcrimes term_limit time_code*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop indep unemployment1  ,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totaldefendants term_limit *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop indep unemployment1  ,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totaldefendants term_limit time_code*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop indep unemployment1  ,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totalcondemned term_limit *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop indep unemployment1  ,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totalcondemned term_limit time_code*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop indep unemployment1  ,fe  cluster (code) 
outreg2  using summarystats1.xls




//// Table 3
xtreg Totalcrimes term_limit *_trend dy*  lightsc  n_partiesc tenurec abstentionc tax_rate total_revc total_expc personnel_expc alignmentc transf_revc fines_fees_revc SupportElectoral Legislatura1 pop rightc leftc indepc unemployment1c unemploymentc,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totalcrimes term_limit time_code*  lightsc  n_partiesc tenurec abstentionc tax_rate total_revc total_expc personnel_expc alignmentc transf_revc fines_fees_revc SupportElectoral Legislatura1 pop rightc leftc indepc unemployment1c unemploymentc,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totaldefendants term_limit *_trend dy* lightsc  n_partiesc tenurec abstentionc tax_rate total_revc total_expc personnel_expc alignmentc transf_revc fines_fees_revc SupportElectoral Legislatura1 pop rightc leftc indepc unemployment1c unemploymentc,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totaldefendants term_limit time_code*  lightsc  n_partiesc tenurec abstentionc tax_rate total_revc total_expc personnel_expc alignmentc transf_revc fines_fees_revc SupportElectoral Legislatura1 pop rightc leftc indepc unemployment1c unemploymentc,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totalcondemned term_limit *_trend dy*  lightsc  n_partiesc tenurec abstentionc tax_rate total_revc total_expc personnel_expc alignmentc transf_revc fines_fees_revc SupportElectoral Legislatura1 pop rightc leftc indepc unemployment1c unemploymentc,fe  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totalcondemned term_limit time_code*  lightsc  n_partiesc tenurec abstentionc tax_rate total_revc total_expc personnel_expc alignmentc transf_revc fines_fees_revc SupportElectoral Legislatura1 pop rightc leftc indepc unemployment1c unemploymentc,fe  cluster (code) 
outreg2  using summarystats1.xls


//// Table 4

xtreg Totalcrimes placebo_term *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment,r  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totalcrimes placebo_term time_code*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment,r  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totaldefendants placebo_term *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment,r cluster (code) 
outreg2  using summarystats1.xls
xtreg Totaldefendants placebo_term time_code*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment,r cluster (code) 
outreg2  using summarystats1.xls
xtreg Totalcondemned placebo_term *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment,r  cluster (code) 
outreg2  using summarystats1.xls
xtreg Totalcondemned placebo_term time_code*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment,r cluster (code) 
outreg2  using summarystats1.xls


//// Table 5

xtreg Corruptioncrimes  term_limit *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment ,r  cluster (code) 
outreg2  using summarystats1.xls
xtreg Corruptiondefendants  term_limit *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment ,r  cluster (code) 
outreg2  using summarystats1.xls
xtreg Corruptioncondemned  term_limit *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep  unemployment,r  cluster (code) 
outreg2  using summarystats1.xls
xtreg Briberydefendants  term_limit *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment ,r cluster (code) 
outreg2  using summarystats1.xls
xtreg Briberycondemned  term_limit *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment ,r  cluster (code) 
outreg2  using summarystats1.xls
xtreg Briberycrimes term_limit *_trend dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment ,r  cluster (code) 
outreg2  using summarystats1.xls



//// Table 6

nbreg Totalcrimes term_limit    lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment, cluster (code) 
outreg2  using summarystats1.xls
nbreg Totalcrimes term_limit  dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment, cluster (code) 
outreg2  using summarystats1.xls
nbreg Totaldefendants term_limit    lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment, cluster (code) 
outreg2  using summarystats1.xls
nbreg Totaldefendants term_limit  dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment, cluster (code) 
outreg2  using summarystats1.xls
nbreg Totalcondemned term_limit    lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment, cluster (code) 
outreg2  using summarystats1.xls
nbreg Totalcondemned term_limit  dy*  lights  n_parties tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep unemployment1 unemployment, cluster (code) 
outreg2  using summarystats1.xls





//// Table 7
tobit Totalcrimes term_limit n_parties lights tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep, ll(0)
outreg2  using summarystats1.xls
tobit Totalcrimes term_limit   dy* n_parties lights tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep, ll(0)
outreg2  using summarystats1.xls
tobit Totaldefendants term_limit n_parties lights tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep,ll(0)
outreg2  using summarystats1.xls
tobit Totaldefendants term_limit dy* n_parties lights tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep,ll(0)
outreg2  using summarystats1.xls
tobit Totalcondemned term_limit n_parties lights tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep, ll(0) 
outreg2  using summarystats1.xls
tobit Totalcondemned term_limit dy* n_parties lights tenure abstention tax_rate total_rev total_exp personnel_exp alignment transf_rev fines_fees_rev SupportElectoral Legislatura1 pop right left indep, ll(0)
outreg2  using summarystats1.xls



